/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package test.db_work;

/**
 *
 * @author snbm
 */
public class Kafedra_speciality {

    int OLD_speciality_id;
    int kafedra_id;
    int OLD_kafedra_speciality_id;
    int NEW_speciality_id;
    private String oldSpecialityName;
    private String newSpecialityName;
    private Speciality_extract se;
    private Speciality_qualification sq;

    @Override
    public String toString() {
        return new StringBuilder()
        .append("-------------------------------------------------------------")
        .append("\nOLD_speciality_id " + OLD_speciality_id)
        .append("\nOLD_kafedra_id " + kafedra_id)
        .append("\nOLD_kafedra_speciality_id " + OLD_kafedra_speciality_id)
        .append("\nNEW_speciality_id " + NEW_speciality_id)
        .append("\noldSpecialityName " + getOldSpecialityName())
        .append("\nnewSpecialityName " + getNewSpecialityName())
        .append("\nSpeciality_extract:::\n " + se)
        .append("\nSpeciality_qualification:::\n " + sq)
        .toString();
    }

    public String make_INSERT_into_kafedra_speciality(){
        return "INSERT INTO onpu.kafedra_speciality VALUES ("+OLD_kafedra_speciality_id+","+OLD_speciality_id+","+kafedra_id+");";
    }

    /**
     * @return the se
     */
    public Speciality_extract getSe() {
        return se;
    }

    /**
     * @param se the se to set
     */
    public void setSe(Speciality_extract se) {
        this.se = se;
    }

    /**
     * @return the sq
     */
    public Speciality_qualification getSq() {
        return sq;
    }

    /**
     * @param sq the sq to set
     */
    public void setSq(Speciality_qualification sq) {
        this.sq = sq;
    }

    public void print_INSERT_ToNewDB() {
        //INSERT TO kafedra_speciality
        System.out.println("");

        //INSERT TO speciality_extract


        //INSERT TO speciality_qualification


    }

    /**
     * @return the oldSpecialityName
     */
    public String getOldSpecialityName() {
        return oldSpecialityName;
    }

    /**
     * @param oldSpecialityName the oldSpecialityName to set
     */
    public void setOldSpecialityName(String oldSpecialityName) {
        this.oldSpecialityName = oldSpecialityName;
    }

    /**
     * @return the newSpecialityName
     */
    public String getNewSpecialityName() {
        return newSpecialityName;
    }

    /**
     * @param newSpecialityName the newSpecialityName to set
     */
    public void setNewSpecialityName(String newSpecialityName) {
        this.newSpecialityName = newSpecialityName;
    }
}
